Custom Target Schema

This option applies to the following targets: SQL Server, SQL Server Azure, PostgreSQL, SAP HANA, DB2, Redshift, and Snowflake.

Unless you specify otherwise, Pyramid will connect to the database's default schema. You can set a custom schema by clicking the Set Schema button from the Target Tables window.

From the Custom Target Schema dialog, enter the required target schema.

You can also set a custom output schema for a given column in the Target Tables window.